﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Store Manager/SM_panel.master" AutoEventWireup="true" CodeFile="SM_GRNHistory.aspx.cs" Inherits="Store_Manager_SM_GRNHIS" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
        ClientIDMode="AutoID" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
        CssPostfix="BlackGlass" DataSourceID="SqlDataSource1" KeyFieldName="GRN_Key" 
        Width="100%">
        <Columns>
            <dx:GridViewDataTextColumn FieldName="GRN_Key" ReadOnly="True" VisibleIndex="0" 
                Visible="False">
                <EditFormSettings Visible="False" />
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Or_ID" VisibleIndex="1" Caption="GRN ID">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Pro_ID" VisibleIndex="2" 
                Caption="Item ID">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Sto_ID" VisibleIndex="3" 
                Caption="Stock ID">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Pro_Name" VisibleIndex="4" 
                Caption="Item">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Cost" FieldName="Pur_Price" 
                ShowInCustomizationForm="True" VisibleIndex="5">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Description" VisibleIndex="6">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Qty" VisibleIndex="7" Caption="Quantity">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Book_GRNno" VisibleIndex="8" 
                Caption="Book GRN No:">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Supplier_Bill_No" VisibleIndex="9" 
                Caption="Supplier Bill No: ">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Supplier " FieldName="Sup_Name" 
                VisibleIndex="10">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="TotalProduct" VisibleIndex="11">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Total" VisibleIndex="12">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn Caption="Status" FieldName="manger_status" 
                VisibleIndex="13">
            </dx:GridViewDataTextColumn>
        </Columns>
        <SettingsPager PageSize="25">
        </SettingsPager>
        <Settings ShowFilterRow="True" />
        <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
            <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
            </LoadingPanelOnStatusBar>
            <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
            </LoadingPanel>
        </Images>
        <ImagesFilterControl>
            <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
            </LoadingPanel>
        </ImagesFilterControl>
        <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
            CssPostfix="BlackGlass">
            <Header ImageSpacing="5px" SortingImageSpacing="5px">
            </Header>
        </Styles>
        <StylesEditors>
            <CalendarHeader Spacing="1px">
            </CalendarHeader>
            <ProgressBar Height="25px">
            </ProgressBar>
        </StylesEditors>
    </dx:ASPxGridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
        
        
        SelectCommand="SELECT Tbl_GRNrequest.GRN_Key, Tbl_GRNrequest.Or_ID, Tbl_GRNrequest.Pur_Price, Tbl_GRNrequest.Description, Tbl_GRNrequest.Sto_ID, Tbl_GRNrequest.Qty, Tbl_GRNrequest.manger_status, Tbl_GRNrequest.Pro_ID, Tbl_SupplierOrder.Supplier_Bill_No, Tbl_SupplierOrder.Sup_Name, Tbl_GRN.TotalProduct, Tbl_GRN.Total, Tbl_GRN.Book_GRNno, Tbl_GRNrequest.Pro_Name FROM Tbl_GRNrequest INNER JOIN Tbl_SupplierOrder ON Tbl_GRNrequest.Or_ID = Tbl_SupplierOrder.Or_ID INNER JOIN Tbl_GRN ON Tbl_SupplierOrder.Or_ID = Tbl_GRN.Or_ID">
    </asp:SqlDataSource>
</asp:Content>

